package com.ruoyi.mapper;

import com.ruoyi.pojo.ResultCompetition;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author kaka.huang
 * @for study
 */
@Mapper
public interface CompetitionMapper {
    // 竞赛成绩全查询接口
    @Select("select game_record.game_id,game_record.game_time,game_record.game_name,game_record.game_result,game_record.top,game_record.certificate,member_info.name from " +
            "game_record left join game_member_mapping on game_record.game_id = game_member_mapping.game_id left join member_info on " +
            "game_member_mapping.member_id = member_info.member_id")
    List<ResultCompetition> selectCompetitionMapper();
}
